Navicat provides User to add, duplicate, edit, delete users, grant/revoke server privileges and privileges on the selected databases, tables/views, fields and functions/procedures. The object pane displays all the users that exist in the user table.
Just simply click to open an object pane for User. A control-click displays the popup menu or use the object pane toolbar, allowing you to add, edit and delete users.
Add User
To add a new user
- Select the connection you wish to set privileges in the navigation pane.
- Click
to open the User showing the user list.
- Click the
from the object pane toolbar or control-click and select New User from the popup menu.
- Edit user properties and privileges on the appropriate tabs of the User Designer.
To create a new user with modification as one of the existing users
- Select the connection you wish to set privileges in the navigation pane.
- Click
to open the User showing the user list.
- Select a user to edit in the object pane.
- Control-click the user and select Duplicate User from the popup menu.
- Edit user properties and privileges on the appropriate tabs of the User Designer.
Edit User
To edit an existing user
- Select the connection you wish to set privileges in the navigation pane.
- Click
to open the User showing the user list.
- Select a user to edit in the object pane.
- Click the
from the object pane toolbar or control-click the user and select Design User from the popup menu.
- Edit user properties and privileges on the appropriate tabs of the User Designer.
Delete User
To delete a user
- Select the connection you wish to set privileges in the navigation pane.
- Click
to open the User showing the user list.
- Select a user to delete in the object pane.
- Click the
from the object pane toolbar or control-click the user and select Delete User from the popup menu.
- Confirm deleting in the dialog window.
Privilege Manager
To edit privilege according to the database objects by using Privilege Manager
- Select the connection you wish to set privileges in the navigation pane.
- Choose Connection -> Set Privileges or control-click the connection and select Set Privileges from the popup menu to open the Privilege Manager window and set privileges.